package com.ruoyi.xiaoshouchuku.mapper;

import java.math.BigDecimal;
import java.util.HashMap;
import java.util.List;
import com.ruoyi.xiaoshouchuku.domain.XiaoshouChuku;
import com.ruoyi.xiaoshouchuku.domain.saomaChuku;
import com.ruoyi.xiaoshouchuku.domain.saomaTest;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

/**
 * 销售出库Mapper接口
 * 
 * @author ruoyi
 * @date 2023-05-15
 */
@Mapper
public interface XiaoshouChukuMapper 
{
    /**
     * 查询销售出库
     * 
     * @param id 销售出库主键
     * @return 销售出库
     */
    public XiaoshouChuku selectXiaoshouChukuById(Long id);

    /**
     * 查询销售出库列表
     * 
     * @param xiaoshouChuku 销售出库
     * @return 销售出库集合
     */
    public List<XiaoshouChuku> selectXiaoshouChukuList(XiaoshouChuku xiaoshouChuku);

    /**
     * 新增销售出库
     * 
     * @param xiaoshouChuku 销售出库
     * @return 结果
     */
    public int insertXiaoshouChuku(XiaoshouChuku xiaoshouChuku);

    /**
     * 修改销售出库
     * 
     * @param xiaoshouChuku 销售出库
     * @return 结果
     */
    public int updateXiaoshouChuku(XiaoshouChuku xiaoshouChuku);

    /**
     * 删除销售出库
     * 
     * @param id 销售出库主键
     * @return 结果
     */
    public int deleteXiaoshouChukuById(Long id);

    /**
     * 批量删除销售出库
     * 
     * @param ids 需要删除的数据主键集合
     * @return 结果
     */
    public int deleteXiaoshouChukuByIds(String[] ids);

    int insertXiaoshouChukuIMGPath(@Param("id") Long id,@Param("Path") String Path);

    String selectGouhuoDanhaoByLastOne();

    String selectRole2User(String username);

    String selectRole4User(String username);

    List<String> selectGendan2User();

    int selectTodo(@Param("goodname")String goodname,@Param("chukudanhao") String chukudanhao,@Param("fahuodanhao") String fahuodanhao);

    boolean insertSaomaChuku(saomaChuku saomaChuku);

    int selectTodo2(@Param("goodname")String goodname,@Param("chukudanhao") String chukudanhao,@Param("fahuodanhao") String fahuodanhao);

    List<saomaTest> selectXiaoshouChukuByDanhao(String fahuoDanhao);

    List<saomaChuku> selectSaomaChuKu4DanGedanhao(String danhao);

    List<saomaChuku> selectSaomaChuKuList(saomaChuku saomaChuku);

    int updateSaomaChuku(saomaChuku sc);

    List<saomaChuku> selectXiaosaomaTest4danhaoAndshangpin(@Param("fahuodanhao") String fahuodanhao,@Param("shangpinBianhao")String shangpinBianhao);

    saomaTest selectsaomaChuku2danhaoAndshangpin(@Param("fahuodanhao")String fahuodanhao,@Param("shangpinBianhao") String shangpinBianhao);
}
